<?php
/* 
 * Init the database for simpleviewer
 */

// simpleViewerGallery tables
$this->createTable('simpleViewerGallery', 'id int(11) NOT NULL auto_increment, svgtitle varchar(255) NOT NULL, svgdescription text, svgthumb_h int(11) NOT NULL, svgthumb_w int(11) NOT NULL, svgdetail_h int(11) NOT NULL, svgdetail_w int(11) NOT NULL, PRIMARY KEY (id)');
$this->createTable('simpleViewerGalleryImage', 'id int(11) NOT NULL auto_increment, sviimage longblob, sviimage_filename varchar(255) NOT NULL, sviimage_type varchar(255) NOT NULL, sviimage_size int(11) NOT NULL, simpleViewerGallery_id int(11) NOT NULL, svidescription text, svisorting int(11) default NULL, PRIMARY KEY  (id), FULLTEXT KEY svidescription (svidescription)', true);

// simpleViewerGallery type tables
$query = "title varchar(255), galleryname varchar(255), gallery int";
$this->customCreateQuery('simpleViewerGallery2', $query);
$this->customCreateQuery('simpleViewerGallery2', $query, true);


?>
